[dbo].[BAEImisProductFunctionGetRegistrationCount]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisProductFunctionGetRegistrationCount

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@productCode	varchar(64)	64

SQL Script

create procedure [dbo].[BAEImisProductFunctionGetRegistrationCount] @productCode varchar(64) as
SELECT CONVERT(int, LTD_QUANTITY) AS 'NumberRegistered'
FROM Product_Inventory
WHERE PRODUCT_CODE = @productCode

GO

Uses

[dbo].[Product_Inventory]
dbo